Text is truncated when exported to Excel because text exceeds Excel limit.
Cause:
This problem occurs when exporting Access tables or queries to MS Excel and is because the length of text in an Access field exceeds the 255-character cell limit in Excel.
Solution:
As a workaround, export the table or query to MS Word.